Implementation of Object Oriented Data Warehousing using a Narrower Compassed Data Model in Oracle 10g

A data warehouse (DW) is a database used for reporting Paper describes Object Oriented Data Warehousing using a narrower compassed data model. The data is offloaded from the operational systems for reporting. The data may pass through an operational data store for additional operations before it is used in the Data warehousing for reporting. An Object Oriented Data Warehouse system includes a data warehouse and underlying data sources. A narrower compassed model is used for storing the data in Object Oriented Data warehouse. Oracle 10g Language is specifically used for the programming. Object Oriented Data Warehousing provides complex objects which include multiple atomic types and user defined object types. The steadiness between the data warehouse and the source databases is maintained by certain algorithms such as insertion, deletion and update. In the past research work on data warehouse was primarily focused on relational data models. The concept of object oriented data warehousing is introduced and implementation of Object oriented data warehouse in oracle 10g. Data model will form new classes according to the definition of views such that query performance & security can be improved.